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