Open kr-seominwoo opened 1 year ago
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT |
---|---|---|---|
NAME | NVARCHAR2(20) | No | - |
ID | VARCHAR2(20) | No | - |
PASSWORD | VARCHAR2(100) | No | - |
NICKNAME | NVARCHAR2(20) | No | - |
VARCHAR2(320) | No | - | |
BIRTHDAY | DATE | No | - |
ROLE | NUMBER | No | 1 |
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT |
---|---|---|---|
POST_ID | NUMBER | No | - |
MEMBER_ID | VARCHAR2(20) | No | - |
WRITER | VARCHAR2(20) | No | - |
TITLE | NVARCHAR2(50) | No | - |
CONTENT | NCLOB | No | - |
REGDATE | DATE | No | SYSDATE |
LIKE | NUMBER | No | 0 |
UNLIKE | NUMBER | No | 0 |
HIT | NUMBER | No | 0 |
CATEGORY | NVARCHAR2(50) | No | (null) |
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT |
---|---|---|---|
COMMENT_ID | NUMBER | No | - |
MBMBER_ID | VARCHAR2(20) | No | - |
WRITER | NVARCHAR2(20) | No | - |
CONTENT | NCLOB | No | - |
REGDATE | DATE | No | SYSDATE |
POST_ID | NUMBER | No | - |
PARENT_ID | NUMBER | No | 0 |
LIKE | NUMBER | No | 0 |
UNLIKE | NUMBER | No | 0 |
BLIND | NUMBER | No | 0 |
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT |
---|---|---|---|
TOKEN | VARCHAR2(32) | No | - |
MBMBER_ID | VARCHAR2(20) | No | - |
EXPIRATION_DATE | TIMESTAMP | No | - |
실무에서는 데이터 정합성 작업으로 성능 저하가 생기므로 외래키 사용을 자제해서 외래키 삭제