takoyaki

Tables (8)

accepted_yaki (수락된 야끼)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • post_id (FK2) — bigint — Foreign key → post.id — NOT NULL
  • created_at (Field2) — timestamp

bookmark (북마크)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • post_id (FK2) — bigint — Foreign key → post.id — NOT NULL
  • created_at (Field) — timestamp

category (카테고리 목록)

  • Key (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

local (활동 지역 목록)

  • id (PK) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

penalty (패널티)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • penalty_type (Field) — int
  • end_date (Field2) — timestamp
  • created_at (Field3) — timestamp

post (게시글)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • closing_date (field) — timestamp
  • view_count (Field12) — int
  • title (Field7) — varchar(100)
  • closing_status (Field) — int
  • recruit_number (Field2) — int
  • contact_method (Field4) — int
  • local (Field3) — int
  • contact (Field5) — varchar(255)
  • duration (Field6) — int
  • body (Field8) — TEXT
  • deletion_status (Field9) — int
  • created_at (Field10) — timestamp
  • updated_at (Field11) — timestamp

user (회원)

  • id (PK) — bigint — Primary key — NOT NULL
  • nickname (field) — varchar(16)
  • email (field2) — varchar(100)
  • social (field3) — int
  • created_at (field4) — timestamp
  • updated_at (field5) — timestamp

waiting_yaki (대기중인 야끼)

  • id (PK) — bigint — Primary key — NOT NULL
  • user_id (FK) — bigint — Foreign key → user.id — NOT NULL
  • post_id (FK2) — bigint — Foreign key → post.id — NOT NULL
  • created_at (Field2) — timestamp