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