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