SharedDB
Tables (6)
CHILD
- CHILDREN_ID — INT — Primary key — NOT NULL
- 식별자 — TBD — Foreign key → USER.식별자 — NOT NULL — 유저를 분별할 유일한 식별자인데 아직 뭐로 할지 안 정해졌음
- ID (ID2) — STRING — Foreign key → USER.ID — NOT NULL
- IDX — INT
- GENDER — STRING
- AGE — INT
COMMON_CODE
- IDX — INT — Primary key — NOT NULL
- VALUE — STRING — Primary key — NOT NULL
- GROUP_NAME — STRING — Foreign key → COMMON_CODE_GROUP.GROUP_NAME — NOT NULL
- NOTE — STRING
- CREATED_TIME — DATETIME
- UPDATED_TIME — DATETIME
COMMON_CODE_GROUP
- IDX — INT — Primary key — NOT NULL
- GROUP_NAME — STRING — Primary key — NOT NULL
- CREATED_TIME — DATETIME
- UPDATED_TIME — DATETIEM
DEAL
- IDX — INT — Primary key — NOT NULL
- TITLE — STRING
- USER_ID — INT
- CATEGORY — STRING
- LOCATION — STRING
- DEAL_TIME — DEAL_TIME
- DEAL_STATUS — STRING
- DEAL_WAY — STRING
- CHAT_NO — INT
- CREATED_TIME — DATETIME
- UPDATED_TIME — DATETIME
- DUE_TIME — DATETIME
- WAIT_PEOPLE_NO — INT
DEAL_WAIT
- IDX — INT — Primary key — NOT NULL
- DEAL_NO — INT — Foreign key → DEAL.IDX — NOT NULL
- USER_ID — STRING
- WAIT_NO — INT
USER
- 식별자 — TBD — Primary key — NOT NULL — 유저를 분별할 유일한 식별자인데 아직 뭐로 할지 안 정해졌음
- ID — STRING — Primary key — NOT NULL
- IDX — INT — NOT NULL — AUTO INCREMENT
- PASSWORD — STRING (ENCRYPT)
- ADDRESS — STRING
- NAME — STRING — 유저 이름
- GIVE — INT — 나눔 횟수
- RECEIVE — INT — 나눔 받은 횟수
- REWARD — INT — 나눔 받을 수 있는 횟수
- CHILDRENS — INT
- CREATED_TIME — DATETIME
- UPDATED_TIME — DATETIME