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