앤티크유니버스ERD

테이블 (3)

Shop

  • shopId — BIGINT(21) — 기본 키 — NOT NULL
  • userId — BIGINT(21) — 외래 키 → User.userId — NOT NULL
  • name — CHAR(20)
  • description — TEXT
  • locationX — DOUBLE
  • locationY — DOUBLE

Stuff

  • stuffId — BIGINT(21) — 기본 키 — NOT NULL
  • shopId — BIGINT(21) — 외래 키 → Shop.shopId — NOT NULL
  • userId — BIGINT(21) — 외래 키 → Shop.userId — NOT NULL
  • name — CHAR(20)
  • description (descriptoin) — TEXT
  • price — INT
  • imageUrl — TEXT
  • isSold — BOOL
  • onlyAdult — BOOL

User

  • userId — BIGINT(21) — 기본 키 — NOT NULL
  • name — CHAR(10)
  • nickname — CHAR(20)
  • phone — INT(11)
  • age — TINYINT