devgram

Tables (23)

Board (Untitled4)

  • board_seq (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • status (Field7)
  • created_at (Field3)
  • updated_at (Field5)
  • like_count (Field4)
  • tag_seq (Key2) — Foreign key → Tag.tag_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL
  • updated_by (Key42) — Foreign key → User.user_seq — NOT NULL

Board_Accuse (Untitled17)

  • Board_Accuse_Seq (Key) — Primary key — NOT NULL
  • content (Field)
  • report_at (Field2)
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • reporter (Key4) — Foreign key → User.user_seq — NOT NULL

Board_Image (Untitled11)

  • board_image_seq (Key) — Primary key — NOT NULL
  • name (Field)
  • path (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL
  • updated_by (Key42) — Foreign key → User.user_seq — NOT NULL

Board_Log (Untitled10)

  • board_log_seq (Key) — Primary key — NOT NULL
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • before_content (Field)

Board_Product (Untitled18)

  • Board_Product_Seq (Key) — Primary key — NOT NULL
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • product_seq (Key3) — Foreign key → Product.product_seq — NOT NULL
  • order (Field)

Board_Tag (Untitled19)

  • Board_Tag_seq (Key) — Primary key — NOT NULL
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • tag_seq (Key3) — Foreign key → Tag.tag_seq — NOT NULL
  • order (Field)

Board_like (Untitled16)

  • board_like_seq (Key) — Primary key — NOT NULL
  • user_seq (Key4) — Foreign key → User.user_seq — NOT NULL
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL

Category (Untitled5)

  • category_seq (Key) — Primary key — NOT NULL
  • name (Field) — UNIQUE
  • color (Field2) — UNIQUE

Chat (Untitled21)

  • Key — Primary key — NOT NULL
  • contents (field)
  • created_at (Field2)
  • chatroom_seq (Key2) — Foreign key → Chatroom.chatroom_seq — NOT NULL

Chatroom (Untitled20)

  • chatroom_seq (Key) — Primary key — NOT NULL
  • name (Field)

Chatroom_paricipant (Untitled22)

  • chatroom_participant_seq (Key) — Primary key — NOT NULL
  • chatroom_seq (Key2) — Foreign key → Chatroom.chatroom_seq — NOT NULL
  • user_seq (Key4) — Foreign key → User.user_seq — NOT NULL

Follow (Untitled6)

  • follow_Seq (Key) — Primary key — NOT NULL
  • follow (Key4) — Foreign key → User.user_seq — NOT NULL
  • follower (Key42) — Foreign key → User.user_seq — NOT NULL

Product (Untitled2)

  • product_seq (Key) — Primary key — NOT NULL
  • title (Field2)
  • content (Field3)
  • hits (Field4)
  • rating (Field5)
  • like_count (Field6)
  • price (Field)
  • category_seq (Key2) — Foreign key → Category.category_seq — NOT NULL

Product_Image (Untitled12)

  • product_image_seq (Key) — Primary key — NOT NULL
  • name (Field)
  • path (Field2)
  • creaetd_at (Field3)
  • updated_at (Field4)
  • product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL
  • updated_by (Key42) — Foreign key → User.user_seq — NOT NULL

Product_Like (찜)

  • product_like_seq (Key) — Primary key — NOT NULL
  • user_seq (Key4) — Foreign key → User.user_seq — NOT NULL
  • product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL

Review (Untitled3)

  • review_seq (Key) — Primary key — NOT NULL
  • mark (Field)
  • content (Field4)
  • status (Field5)
  • creaetd_at (Field2)
  • product_seq (Key2) — Foreign key → Product.product_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL

Review_Accuse (Untitled15)

  • Key — Primary key — NOT NULL
  • content (Field2)
  • report_at (Field3)
  • review_seq (Key2) — Foreign key → Review.review_seq — NOT NULL
  • reporter (Key4) — Foreign key → User.user_seq — NOT NULL

Review_Image (Untitled13)

  • review_image_seq (Key) — Primary key — NOT NULL
  • name (Field)
  • path (Field2)
  • created_at (Field3)
  • updated_at (Field4)
  • review_seq (Key2) — Foreign key → Review.review_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL
  • updated_by (Key42) — Foreign key → User.user_seq — NOT NULL

Tag (Untitled7)

  • tag_seq (Key) — Primary key — NOT NULL
  • name (Field) — UNIQUE
  • use_count (Field2)

USER_Image (Untitled8)

  • file_seq (Key) — Primary key — NOT NULL
  • user_seq (Key42) — Foreign key → User.user_seq — NOT NULL
  • name (Field)
  • path (Field2)
  • created_at (Field4)
  • updated_at (Field3)
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL
  • updated_by (Key43) — Foreign key → User.user_seq — NOT NULL

User (Untitled)

  • user_seq (Key4) — Primary key — NOT NULL
  • name (Field2)
  • password (Field3)
  • email (Field4) — UNIQUE
  • status (Field5)
  • role (Field6)
  • annual (Field)
  • job (Field11)
  • follow_count (Field12)
  • follower_count (Field13)
  • created_at (Field7)
  • created_by (Field8)
  • updated_at (Field9)
  • updated_by (Field10)

comment (Untitled9)

  • comment_seq (Key) — Primary key — NOT NULL
  • content (Field)
  • status (Field2)
  • created_at (Field3)
  • parent_comment_seq (Key3) — Foreign key → comment.comment_seq — NOT NULL
  • board_seq (Key2) — Foreign key → Board.board_seq — NOT NULL
  • created_by (Key4) — Foreign key → User.user_seq — NOT NULL

comment_Accuse (Untitled14)

  • comment_accuse_Seq (Key) — Primary key — NOT NULL
  • content (Field2)
  • report_at (Field3)
  • comment_seq (Key2) — Foreign key → comment.comment_seq — NOT NULL
  • user_seq (Key4) — Foreign key → User.user_seq — NOT NULL