ÀÌ Å×ÀÌºí¿¡´Â ÷ºÎ¿¡ ´ëÇÑ Á¤º¸¸¦ Æ÷ÇÔÇϰí ÀÖ½À´Ï´Ù. ÷ºÎ´Â °Å·¡ ¹®¼¿¡ ´ëÇÑ Áö¿ø ¹®¼ÀÔ´Ï´Ù. ¿¹¸¦ µé¾î, »óǰ ½ºÆåÀ̳ª °¡°Ý ¸ñ·Ï ½ºÇÁ·¹µå½ÃÆ®ÀÏ ¼ö ÀÖ½À´Ï´Ù.
¿ À̸§ | ¿ À¯Çü | ¿ ¼³¸í |
---|---|---|
ATTACHMENTURL | VARCHAR (254) NOT NULL |
÷ºÎÀÇ URL. |
ATTACHMENT_ID | BIGINT NOT NULL |
÷ºÎ ID (1Â÷ Ű). |
ATTACHUSG_ID | CHARACTER (64) NULL |
÷ºÎ »ç¿ë¹ý (ATTACHUSG) Å×À̺íÀÇ Foreign key. |
CONTENT | BLOB (10000000) NULL |
2Áø ¾ç½ÄÀÇ Ã·ºÎ ÄÁÅÙÃ÷ |
CREATEMETHOD | INTEGER NULL, DEFAULT 0 |
÷ºÎ ÀÛ¼º ¹æ¹ý: 0 = ¼öµ¿. 1 = ¾÷·Îµå. |
DESCRIPTION | VARCHAR (254) NULL |
÷ºÎÀÇ °£´ÜÇÑ ¼³¸í. |
FILENAME | VARCHAR (254) NULL |
Ŭ¶óÀÌ¾ðÆ® ½Ã½ºÅÛÀ¸·ÎºÎÅÍÀÇ ·ÎÄà ÆÄÀÏ À̸§. ATTACHMENTURL°ú µ¿ÀÏÇÏÁö ¾ÊÀ» ¼ö ÀÖÀ½. |
FILESIZE | BIGINT NULL |
÷ºÎ ÆÄÀÏÀÇ Å©±â |
IMAGE1 | VARCHAR (254) NULL |
÷ºÎ¿Í ¿¬°üµÈ À̹ÌÁö ¶Ç´Â ¾ÆÀÌÄÜ. |
IMAGE2 | VARCHAR (254) NULL |
÷ºÎ¿Í ¿¬°üµÈ À̹ÌÁö ¶Ç´Â ¾ÆÀÌÄÜ. |
MARKFORDELETE | INTEGER NOT NULL, DEFAULT 0 |
÷ºÎ¸¦ µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ®·Î »èÁ¦ Ç¥½ÃÇß´ÂÁö ³ªÅ¸³À´Ï´Ù. 0 = ¾Æ´Ï¿À 1 = ¿¹ |
MEMBER_ID | BIGINT NOT NULL |
÷ºÎÀÇ ¼ÒÀ¯ÀÚ. |
MIMETYPE | VARCHAR (254) NULL |
÷ºÎ mimeType. |
MIMETYPEENCODING | VARCHAR (128) NULL |
÷ºÎ ÀÎÄÚµù. |
RESERVED | VARCHAR (254) NULL |
»ç¿ëÀÚ Á¤ÀÇ °¡´É. |
TIMECREATED | TIMESTAMP NULL |
÷ºÎ ÀÛ¼º ½Ã°£. |
TIMEUPDATED | TIMESTAMP NULL |
¸¶Áö¸·À¸·Î ÷ºÎ°¡ °»½ÅµÈ ½Ã°£. |
»öÀÎ À̸§ | »öÀÎÈµÈ ¿ À̸§ | »öÀÎ À¯Çü |
---|---|---|
I0000017 | ATTACHMENTURL | °íÀ¯ »öÀÎ |
I0000290 | ATTACHUSG_ID | °íÀ¯ÇÏÁö ¾ÊÀº »öÀÎ |
SQL030416034837200 | ATTACHMENT_ID | 1Â÷ Ű |
Á¦ÇÑÁ¶°Ç | ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_67 | ATTACHUSG_ID | ATTACHUSG | ATTACHUSG_ID | °è´Ü½Ä |
F_68 | MEMBER_ID | MEMBER | MEMBER_ID | °è´Ü½Ä |
Á¦ÇÑÁ¶°Ç | ÂüÁ¶µÇ´Â ¿ À̸§ | ¿ÜºÎ Å×À̺í À̸§ | ¿ÜºÎ ¿ À̸§ | ]Á¦ÇÑÁ¶°Ç À¯Çü |
---|---|---|---|---|
F_1004 | ATTACHMENT_ID | PATTRVALUE | ATTACHMENT_ID | °è´Ü½Ä |
F_1016 | ATTACHMENT_ID | ATTRVALUE | ATTACHMENT_ID | °è´Ü½Ä |
F_868 | ATTACHMENT_ID | TRDATTACH | ATTACHMENT_ID | °è´Ü½Ä |