orang_v1
Tables (14)
Agreement
- id — BIGINT — Primary key — NOT NULL
- member_id (id2) — bigint — Foreign key → Member.id — NOT NULL
- term_id (id3) — bigint — Foreign key → Term.id — NOT NULL
Booth
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- type — ENUM — NOT NULL
- location — POINT
- open_time — TIME
- close_time — TIME
- festival_id — bigint — NOT NULL
ChatMessage
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- send_at — TIMESTAMP — NOT NULL
ChatRoom
- id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ChatRoomParticipant
- id — BIGINT — Primary key — NOT NULL
- room_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL — 참여자
- last_read_message — BIGINT — NOT NULL — 읽음 처리 기준 메세지
- joined_at — TIMESTAMP — NOT NULL
Chingurang
- id — BIGINT — Primary key — NOT NULL
- author_id — BIGINT — NOT NULL — 작성자
- festival_id — BIGINT — NOT NULL — 축제
- title — VARCHAR — NOT NULL — 제목
- content — TEXT — 내용
- recruit_count — SMALLINT — NOT NULL — 모집자수
- gender — ENUM — NOT NULL — 성벽
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ChingurangComment
- id — BIGINT — Primary key — NOT NULL
- chingurang_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
- parent_id — BIGINT — 부모댓글
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
ChingurangLike
- id — BIGINT — Primary key — NOT NULL
- chingurang_id — BIGINT — NOT NULL
- member_id — BIGINT — NOT NULL
Event
- id — BIGINT — Primary key — NOT NULL
- date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME
- artist — VARCHAR
- festival_id — bigint — NOT NULL
Festival
- id — bigint — Primary key — NOT NULL
- name — varchar — NOT NULL
- address — TEXT — NOT NULL
- location — POINT — NOT NULL
- description — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
Map
- id — BIGINT — Primary key — NOT NULL
- image — TEXT — NOT NULL
- festival_id — bigint — NOT NULL
Member
- id — bigint — Primary key — NOT NULL
- nickname — VARCHAR — NOT NULL
Menu
- id — BIGINT — Primary key — NOT NULL
- festival_id — bigint — NOT NULL
- name — VARCHAR — NOT NULL
- description — TEXT
- price — INT — NOT NULL
- image — TEXT
Term
- id — INT — Primary key — NOT NULL
- name — VARCHAR — NOT NULL
- content — TEXT — NOT NULL
- optional — BOOLEAN — NOT NULL