공통pjt
테이블 (14)
Answer (Untitled11)
- q_id (Key) — varchar — 외래 키 → Question.question_id — NOT NULL
- content (Field) — varchar — NOT NULL
- created_at (Field2) — varchar — NOT NULL
Comment (Untitled9)
- gc_id (Key) — varchar — 외래 키 → GameCommunity.gc_id
- email (Key2) — varchar — 외래 키 → User.email — NOT NULL
- content (Field) — varchar — NOT NULL
- created_at (Field2) — datetime — NOT NULL
- updated_at (Field3) — datetime — NOT NULL
Follow (Untitled12)
- follower (Key) — varchar — 외래 키 → User.email — NOT NULL
- following (Key2) — varchar — 외래 키 → User.email — NOT NULL
Funding (Untitled3)
- funding_id (Key) — varchar — 기본 키 — NOT NULL
- game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL
- email (Key3) — varchar — 외래 키 → User.email — NOT NULL
- money (Field) — int
- funded_at (Field2) — datetime — NOT NULL
Game (Untitled2)
- game_id (Key) — varchar — 기본 키 — NOT NULL
- name (Field) — varchar — NOT NULL
- deadline (Field2) — date — NOT NULL
- aim (Field4) — int
- left (Field5) — int
- is_end (Field6) — boolean
- email (Key2) — varchar — 외래 키 → User.email — NOT NULL
- thumbnail (Field3) — varchar — NOT NULL
- created_at (Field7) — datetime — NOT NULL
- updated_at (Field8) — datetime — NOT NULL
- status (Field9) — varchar — NOT NULL
GameCommunity (Untitled8)
- gc_id (Key) — varchar — 기본 키 — NOT NULL
- email (Key2) — varchar — 외래 키 → User.email — NOT NULL
- game_id (Key3) — varchar — 외래 키 → Game.game_id — NOT NULL
- title (Field) — varchar — NOT NULL
- content (Field2) — varchar — NOT NULL
- created_at (Field3) — date — NOT NULL
- updated_at (Field4) — datetime — NOT NULL
GameDetail (Untitled5)
- game_id (Key) — varchar — 외래 키 → Game.game_id — NOT NULL
- content (Field) — varchar
- d_stage (Field3) — int — NOT NULL
Game_genre (Untitled7)
- game_genre_id (Key) — varchar — 기본 키 — NOT NULL
- game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL
- genre_id (Key3) — varchar — 외래 키 → Genre.genre_id — NOT NULL
Genre (Untitled6)
- genre_id (Key) — varchar — 기본 키 — NOT NULL
- name (Field) — varchar — NOT NULL
Like (Untitled13)
- user (Key) — varchar — 외래 키 → User.email — NOT NULL
- game_id (Key2) — varchar — 외래 키 → Game.game_id — NOT NULL
Question (Untitled10)
- question_id (Key) — varchar — 기본 키 — NOT NULL
- q_email (Key2) — varchar — 외래 키 → User.email — NOT NULL
- game_id (Key3) — varchar — 외래 키 → Game.game_id — NOT NULL
- title (Field) — varchar — NOT NULL
- content (Field2) — varchar — NOT NULL
- is_resolved (Field3) — boolean — NOT NULL
- created_at (Field5) — datetime\ — NOT NULL
Reward (Untitled4)
- reward_id (Key2) — varchar — 기본 키 — NOT NULL
- game_id (Key) — varchar — 외래 키 → Game.game_id — NOT NULL
- name (Field) — varchar
- r_img (Field2) — varchar
- left (Field3) — int
- price (Field4) — int
- content (Field5) — varchar
User (Untitled)
- email (Key) — varchar — 기본 키 — NOT NULL
- name (Field) — varchar — NOT NULL
- password (Field2) — varchar — NOT NULL
- address (Field3) — varchar
- account (Field4) — varchar
- is_developer (Field5) — boolean — NOT NULL
- phone_number (Field6) — varchar
- is_admin (Field7) — boolean — NOT NULL
communityLike (Untitled14)
- email (Key) — varchar — 외래 키 → User.email — NOT NULL
- gc_id (Key2) — varchar — 외래 키 → GameCommunity.gc_id — NOT NULL