cultureland

Tables (3)

Category (카테고리)

  • id (카테고리아이디) — BIGINT — Primary key — NOT NULL
  • name (카테고리이름) — VARCHAR

Event (행사)

  • id (행사아이디) — BIGINT — Primary key — NOT NULL
  • memberId (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
  • categoryId (카테고리아이디) — BIGINT — Foreign key → Category.id — NOT NULL
  • title (제목) — VARCHAR
  • description (설명) — VARCHAR
  • price (가격) — INT
  • location (장소) — VARCHAR
  • startDate (시작일시) — DATETIME
  • endDate (종료일시) — DATETIME

Member (멤버)

  • id (회원아이디) — BIGINT — Primary key — NOT NULL
  • kakaoId (카카오아이디) — VARCHAR
  • nickname (닉네임) — VARCHAR
  • role (권한) — VARCHAR