board

Tables (9)

author (Untitled)

  • 글쓴이ID (ID) — BIGINT — Primary key — NOT NULL
  • 주소 (address) — varchar(255)
  • 이름 (name) — varchar(255)
  • 패스워드 (password) — varchar(255)
  • 이메일 (email) — varchar(255)
  • 가입일 (created_ftime) — datetime — NOT NULL

author_address (Untitled3)

  • 주소ID (id) — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (author_id) — BIGINT — Foreign key → author.글쓴이ID — NOT NULL
  • 국가 (country) — varchar(255)
  • 도시 (city) — varchar(255)
  • 상세주소 (street) — varchar(255)
  • 생성시간 (created_time) — datetime

author_post (Untitled4)

  • id — BIGINT — Primary key — NOT NULL
  • 글쓴이ID (author_id) — BIGINT — Foreign key → author.글쓴이ID — NOT NULL
  • 글ID (posted_id) — BIGINT — Foreign key → post.글ID — NOT NULL
  • 생성시간 (created_time) — datetime

buyer (Untitled9)

  • Key — Primary key — NOT NULL
  • 구매자 (Field)
  • 생성시간 (Field2)

order (Untitled8)

  • Key — Primary key — NOT NULL
  • 주문번호 (Field)
  • 생성시간 (Field3)

post (Untitled2)

  • 글ID (id) — BIGINT — Primary key — NOT NULL
  • 제목 (title) — varchar(255)
  • 내용 (content) — varchar(255)
  • 생성시간 (created_time) — datetime

product (Untitled6)

  • Key (bigint) — char — Primary key — NOT NULL
  • 상품명 (product_name) — varchar(255) — NOT NULL
  • 재고 (quantity) — int(100) — NOT NULL
  • 판맺자정보 (seller_informaion) — varchar(255) — NOT NULL
  • 상품상세 (content) — varchar(255) — NOT NULL
  • 등록시간 (update_time) — datetime — NOT NULL

seller (Untitled7)

  • Key — Primary key — NOT NULL
  • 판매자명 (Field) — NOT NULL
  • 생성시간 (Field2)
  • 판매시간 (Field3) — NOT NULL

user (Untitled5)

  • user (ID) — bigint — Primary key — NOT NULL
  • 구분 (status) — varchar(255) — NOT NULL
  • 이름 (name) — varchar(255) — NOT NULL
  • 비번 (password) — varchar(255) — NOT NULL
  • 이메일 (email) — varchar(255) — NOT NULL
  • 가입일ㄹ (created_time) — datetime — NOT NULL